Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_59

R_59

InsuranceDocumentType

InsuranceDocumentTypeText

InsuranceDocumentTypeID

 

 

R_154

R_154

Address

LInsurerAddress

AddressID

 

 

R_159

R_159

Insurer

LInsurerAddress

InsurID

 

 

R_160

R_160

Patient

LPatientInsurer

PersonID

 

 

R_161

R_161

Insurer

LPatientInsurer

InsurID

 

 

R_324

R_324

InsuranceDocumentType

LPatientInsurer

InsuranceDocumentTypeID

 

 

R_325

R_325

Employer

LEmployerAddress

EmployerID

 

 

R_326

R_326

Address

LEmployerAddress

AddressID

 

 

R_327

R_327

Employer

Patient

EmployerID

 

 

R_487

R_487

PatientsGroup

LPatientGroup

PatientsGroupID

 

 

R_488

R_488

Patient

LPatientGroup

PersonID

 

 

R_930

R_930

Employer

LPatientEmployer

EmployerID

 

 

R_932

R_932

Person

LPatientEmployer

PersonID

 

 

R_946

R_946

PatientsGroup

LEmployerPatientGroup

PatientsGroupID

 

 

R_947

R_947

Employer

LEmployerPatientGroup

EmployerID

 

 

R_1547

R_1547

Insurer

LInsuranceDocumentTypeInsurer

InsurID

 

 

R_1548

R_1548

InsuranceDocumentType

LInsuranceDocumentTypeInsurer

InsuranceDocumentTypeID

 

 

R_1673

R_1673

Country

CountryText

CountryID

 

 

R_1674

R_1674

Country

LPatientInsurer

CountryID

 

 

R_1675

R_1675

InsuranceRights

InsuranceRightsText

InsuranceRightsID

 

 

R_1676

R_1676

InsuranceRights

LPatientInsurer

InsuranceRightsID

 

 

R_1677

R_1677

FinancingAgency

FinancingAgencyText

FinancingAgencyID

 

 

R_1678

R_1678

FinancingAgency

LPatientInsurer

FinancingAgencyID

 

 

R_1679

R_1679

Country

Person

CountryID

 

 

R_1680

R_1680

AdmCode

LPatientInsurer

AdmCodeID

 

 

R_1681

R_1681

InsuranceRights

LInsDocumentTypeInsRights

InsuranceRightsID

 

 

R_1682

R_1682

InsuranceDocumentType

LInsDocumentTypeInsRights

InsuranceDocumentTypeID

 

 

R_1940

R_1940

Institution

LPatientInsurer

InstitutionID

 

 

R_3007

R_3007

FinancingAgency

LFinancingAgencyInsRights

FinancingAgencyID

 

 

R_3008

R_3008

InsuranceRights

LFinancingAgencyInsRights

InsuranceRightsID

 

 

R_5091

R_5091

Country

Address

CountryID

 

 

R_8430

R_8430

Country

Institution

CountryID

 

 

R_8690

R_8690

Person

PatientOrgUnitConfig

PersonID

 

 

R_8692

R_8692

PatientOrgUnitConfigType

PatientOrgUnitConfig

PatientOrgUnitConfigTypeID

 

 

R_8693

R_8693

PatientOrgUnitConfigType

PatientOrgUnitConfigTypeText

PatientOrgUnitConfigTypeID

 

 

R_8715

R_8715

Person

PatientTransport

PersonID

 

 

R_8716

R_8716

Address

PatientTransport

AddressID

 

 

R_8872

R_8872

Episode

LPatientTypeEpisode

EpisodeID

 

 

R_8873

R_8873

PatientType

LPatientTypeEpisode

PatientTypeID

 

 

R_8874

R_8874

PatientType

PatientTypeText

PatientTypeID

 

 

R_8956

R_8956

AdmCode

Insurer

AdmCodeID

 

 

R_9173

R_9173

Person

LPatientInsurer

DocumentHolderPersonID

 

 

R_9467

R_9467

Person

PersonDisabilityLevel

PersonID

 

 

R_9468

R_9468

DictionaryValue

PersonDisabilityLevel

DisabilityLevelID

 

 

R_9733

R_9733

Category

LCategoryPatient

CategoryID

 

 

R_9734

R_9734

SocialStatus

Patient

SocialStatusID

 

 

R_9735

R_9735

Patient

LCategoryPatient

PersonID

 

 

R_9736

R_9736

CategoryDictionary

LCategoryPatient

CategoryDictionaryID

 

 

R_9737

R_9737

ICD

PersonDisabilityLevel

ICDID

 

 

R_9765

R_9765

Event

Talon

EventID

 

 


2